excel动态引用的问题答:然后在SHEET1表A1输入公式:=IF(ROW()>SUMPRODUCT(1/COUNTIF(DATA2,DATA2)),INDEX(Sheet3!A:A,SMALL(IF((COUNTIF(DATA2,DATA3)=0)*(MATCH(DATA3,DATA3,)=ROW(DATA3)),ROW(DATA3),65536),ROW()-SUMPRODUCT(1/COUNTIF(DATA2,DATA2)))&"",INDEX(DATA2,SMALL(IF(MATCH(DATA2,DATA2,...